Report GLO AnaCredit

spc0025 - observed agent delivery spc0025 each observed agent is reported as one unique counterparty

Card of business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

Name	observed agent delivery spc0025 each observed agent is reported as one unique counterparty
Code	spc0025
Comment	Each observed agent delivery combination also reported 1 and only 1 counterparty. This check ensures that the existing relationship and cardinality between OAD and counterparty can also be checked technically.
Rule Type	Definition

Server expression of the business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

FOR
'observed_agent_delivery.reported_as_counterparty_identifier',
'observed_agent_delivery.reporting_agent_identifier',
observed_agent_delivery .reporting_reference_date

FROM observed_agent_delivery

JOIN counterparty
ON observed_agent_delivery.reported_as_counterparty_identifier = counterparty.counterparty_identifier
AND observed_agent_delivery.reporting_agent_identifier = counterparty.reporting_agent_identifier
AND observed_agent_delivery.reporting_reference_date = counterparty.reporting_reference_date

GROUP BY
observed_agent_delivery.reported_as_counterparty_identifier,
observed_agent_delivery.reporting_agent_identifier,
observed_agent_delivery.reporting_reference_date

COUNT observed_agent_delivery.reported_as_counterparty_identifier = 1

List of DNB-specific attributes of the business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

business rule classification

specialisation model constraint

business rule scope

Checked within the data delivery

business rule status

active business rule

number of dependencies

severity

blocking

List of attached objects of the business rule observed agent delivery spc0025 each observed agent is reported as one unique counterparty

Entity Attribute 'observed agent delivery.reported as counterparty identifier'

Home